<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<jsp:useBean id="db" class="connBean.ConnDB" scope="page">
</jsp:useBean>
<%@ include file="Logined.jsp" %>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #EEF2FB;
}
-->
</style>
<body>
<table width="100%"  height="97%"border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" height="35" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
        <td height="31"><div class="titlebt">查询商品</div></td>
      </tr>
    </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td height="149" valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" height="100%" bgcolor="#F7F8F9">
    


<form action="seniorselectrs.jsp" method="post">
<table>						
					<tr><td><label>关键字</label></td>
					<td><input name="mainkey" type="text"  /></td></tr>	
						
						
					<tr><td>	<label>商品种类</label></td>
						<td><select name="second_type" class="field">
					        <option value="0">选择种类</option>
							<%db.OpenConn();
							  db.createStmt();
							  String sql_type="select * from second_type";
							  ResultSet second_type=db.Query(sql_type);
							  while(second_type.next())
							  {%>
							  <option value="<%=second_type.getInt("st_id") %>"><%=second_type.getString("st_name") %></option>
							  <%}db.closeStmt();
							  db.closeConn();
							  %>
						</select>
						</td></tr>
						
						<tr><td><label>价格区间</label></td>	
							<td><select name="price_1" class="field small-field">
							    <option value="0">选择下限</option>
								<option value="10">￥10</option>
								<option value="50">￥50</option>
								<option value="100">￥100</option>
								<option value="200">￥200</option>
								<option value="500">￥500</option>
							</select>
							<label>至:</label>
							<select name="price_2" class="field small-field">
							    <option value="1000000000">选择上限</option>
								<option value="50">￥50</option>
								<option value="100">￥100</option>
								<option value="200">￥200</option>
								<option value="500">￥500</option>
								<option value="1000">￥1000</option>
							</select>
						</td></tr>
						
					<tr><td colspan=2>	<input type="submit" class="search-submit" value="搜索" /></td>

	</table>
					</form>




</td>
    <td background="images/mail_rightbg.gif">&nbsp;</td>
  </tr>
  <tr>
    <td valign="bottom" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td>
    <td background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17"></td>
    <td valign="bottom" background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td>
  </tr>
</table>
</body>